ISO3166-1Country

Entity Definition

Logical Name : ISO3166-1Country
Physical Name : LO_CY_ISO

Locality in which the retailer does business. Provides a mapping from ISO-3166-1 two-character codes to country names. Provides a mapping from ISO-3166-1 two-character codes to the ITU assigned telephone number dialling code.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ISOCountryCode (PK) The ISO-3166-1 two letter code denoting a locality in which the retailer does business. CD_CY_ISO Code2 char(2)
ITUCountryCode (FK) A 1 - 3 digit telephone number dialling code denoting a Country or similar locality as assigned by the International Telgraphic Union (ITU). CD_CY_ITU PhoneNumberCountryCode char(3) ITUCountry(LO_CY_ITU)
CountryName The name of a locality in which the retailer does business. NM_CY Name varchar(40)
ISO3166ThreeCharacterCountryCode ISO designated three character abbreviation for a country, CD_ISO_3CHR_CY Code4 char(4)

Relationships

Parent Entity Verb Phrase Child Entity
ITUCountry covers ISO3166-1Country
ISO3166-1Country is origin for ItemCountryOrigin
ISO3166-1Country is origin of SupplierItemCountryOrigin
ISO3166-1Country is celebrated by Holiday
ISO3166-1Country contains ISO3166-2CountrySubdivision
ISO3166-1Country is country of METARweatherSite
ISO3166-1Country identifies GeographicSegmentHierarchyGroup
ISO3166-1Country authorizes PostalCodeReference
ISO3166-1Country issues ISO4217-CurrencyType

Logical Views containing ISO3166-1Country

Logical View
Logical 01000 - Item Description - Macro View
Logical 01500 - Item Supplier View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 05100 - Taxation - Rules View
Logical 06100 - Calendar View
Logical 06320 - Party - Address and Contact View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10102 - EnterpriseWeather
Logical 10104 - Enterprise Currency
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View
Logical 21000 - Fresh Item Management Macro View